Based on discussion with students, I now believe that games vary enough among regions that a “Game Version” is a particular game, for a particular platform/system, for a particular region. A lot of key info would then be part of game version: ESRB rating, quality rating, release date.
This means that some of the queries have to be adjusted. See below.
Note that a first installment is due Nov 17, and the completed project is due Dec 8. The will be a handout later on final project deliverables.
Tentative Queries / Reports:
1. Show all Games, with Publisher Name, Game Name, Genre, ordered by Publisher Name and Game Name.
2. Show all games from Publisher X, with Game Name, Genre, ordered by Genre.
3. Show all Games with Genre X, with Publisher Name and Game Name.
4. Show all Games with Genre X, and ESRB Rating Y, with Publisher Name, Game Name, System/Platform Name, and Region Name
5. Show all Game Versions for Game X, With System/Platform Name, Region Name, quality rankings from Games.com, and System requirements
6. Show all Game Versions for System (platform) X, available in Region Y, with Publisher Name, Game Name, Game Genre, Game ESRB rating, Game Version quality rankings from Games.com, and System Requirements
7. Show all prices for Game X, for System/Platform Y, in Region Z, with Retailer Name, price
8. Show all release dates for Region X, with Game Name, System/Platform Name
9. Show all release dates for Game X, with Game Name, System/Platform Name, and Region Name.
10. Show all PC Game Versions available in Region X that run in Windows XP, with Game Name, Publisher Name, Genre, ESRB rating, Games.com quality rating, and Release Date.
11. Show all Game Versions for System/Platform X, released since Year Y, with Game Name, Publisher Name, Region Name, Game Genre, Game ESRB rating, Game Version quality rankings from Games.com, and System Requirements
12. Show the total number of Games by Genre
13. Show the total number of Games Versions by ESRB rating
14. Show the total number of Game Versions, by Region
15. Show the total number of Game Versions by Platform
16. Show the total number of Game Versions by Retailer
17. Show for System/Platform X, show the Average Price by Retailer
18. Show for Game X, show the Lowest Price by System/Platform
19. Show the Average Games.com quality rating by Publisher
NOTES: - Notes from the original project hand out still apply